How to: Search for data in a table.
Solution:
Select the 'Edit' menu and select 'Find...', type what to search for in the 'Find What' box, and click 'Find First'.
1) If the Database window is not active, activate the Database window.
2) Open the table in the Table Datasheet view.
3) Select the 'Edit' menu and select 'Find...'. (The Find dialog box appears.)
4) Type what to search for in the 'Find What' box.
Find What box
5) Make sure the 'Search Only Current Field' check box is NOT checked.
Search Only Current Field
6) (Optional) Select any other desired check boxes.
7) Click 'Find First'. (The first record meeting the criteria typed in step 4) is found. The found string is highlighted so that when the change is entered, it completely replaces the existing highlighted string.)
8) (Optional) Click 'Close', to close the 'Find' dialog box and make any changes to the record.
9) To find additional records with the same criteria:
a) (Special Case) If 'Close' was chosen in step 8), select The 'Edit' menu and select 'Find'. (The Find dialog box appears with the same criteria still in the Find What box.)
b) Click 'Find Next'.
c) (Optional) Click 'Close' to close the 'Find' dialog box and make any changes to the record.
d) Repeat steps 9)a) through 9)c) for each additional record meeting the criteria. (When the last record is reached, the next one to appear will be the first one meeting the criteria that had appeared in step 7) above.)
10) Click 'Close' to close the 'Find' dialog box.
